package com.LFLWZ.mapper;

import com.LFLWZ.beans.POJO.*;
import com.LFLWZ.beans.Vo.ClassroomCourseVo;
import com.LFLWZ.beans.Vo.LecturerAndCloudLogin;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface worksMapper {

    /**
     * 按照日记类型查询年月日总数
     * @param special rijileixng
     * @return
     */
    List<Worksshow>selCountTime(@Param("special") Integer special,Integer uid);

    int addWorks(Worksshow WorksinfoVo);

    List<Worksshow> selWorks(Worksshow worksshow);

    Worksshow sqlById (Integer id);

    List<LecturerApply>selLecturer(LecturerApply lecturerApply);

    int updAudit(LecturerApply lecturerApply);

    int update(Worksshow worksshow);

    int deleteById(Integer id);

    /***
     * 查询全部讲师(讲师管理)
     * @param lecturer 实体类
     * @return
     */
    List<Lecturer>selall(Lecturer lecturer);

    /***
     * 查询讲师类型
     * @param excellent
     * @return
     */
    List<Lecturer> selexc(@Param("excellent") Integer excellent );

    /***
     * 查询讲师(讲师管理)
     * @return
     */
    List<LecturerAndCloudLogin> Lsel(LecturerAndCloudLogin lecturerAndCloudLogin);

    /***
     * 添加讲师(讲师管理)
     * @param lecturer
     * @return
     */
    int inslecturer(Lecturer lecturer);

    /***
     * 修改讲师(讲师管理)
     * @param lecturer
     * @return
     */
    int upData(Lecturer lecturer);

    /***
     * 删除讲师(讲师管理)
     */
    int del(Integer id);

    /***
     * 查询专栏(课程专栏)
     */
    List<Column> selCol(Column column);

    /***
     * 添加专栏(课程专栏)
     */
    int insCol(Column column);

    /***
     * 修改专栏(课程专栏)
     */
    int upCol(Column column);

    /***
     * 删除专栏(课程专栏)
     */
    int delCol(Integer id);

    List<ClassroomCourseVo> selClass(ClassroomCourseVo classroomCourseVo);

    int insLogin(CloudLogin cloudLogin);

    int insLink(CloudLogin cloudLogin);

    List<CloudLogin> selUid(CloudLogin cloudLogin);

    List<Lecturer> selLeUid(Lecturer lecturer);

    List<Lecturer> selBy(Lecturer lecturer);

    int LeCount();
}
